CREATE TABLE [dbo].[Prospect]
(
[ProspectKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Prospect_ProspectKey] DEFAULT (newid()),
[Prefix] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Prospect_Prefix] DEFAULT (''),
[FirstName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_FirstName] DEFAULT (''),
[MiddleName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_MiddleName] DEFAULT (''),
[LastName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_LastName] DEFAULT (''),
[Suffix] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Suffix] DEFAULT (''),
[FullName] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_FullName] DEFAULT (''),
[Title] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Title] DEFAULT (''),
[Organization] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Organization] DEFAULT (''),
[Address1] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Address1] DEFAULT (''),
[Address2] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Address2] DEFAULT (''),
[Address3] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Address3] DEFAULT (''),
[City] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_City] DEFAULT (''),
[StateProvince] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_StateProvince] DEFAULT (''),
[PostalCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_PostalCode] DEFAULT (''),
[Country] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Country] DEFAULT (''),
[HomePhone] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_HomePhone] DEFAULT (''),
[WorkPhone] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_WorkPhone] DEFAULT (''),
[Fax] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Fax] DEFAULT (''),
[Email] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_Email] DEFAULT (''),
[ImisID] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_ImisID] DEFAULT (''),
[ProspectID] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_ProspectID] DEFAULT (''),
[ListCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_ListCode] DEFAULT (''),
[ImportDate] [datetime] NULL,
[LastFirst] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_LastFirst] DEFAULT (''),
[CompanySort] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Prospect_CompanySort] DEFAULT (''),
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Prospect] ADD CONSTRAINT [PK_Prospect] PRIMARY KEY CLUSTERED ([ProspectKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_City] ON [dbo].[Prospect] ([City]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_CompanySort] ON [dbo].[Prospect] ([CompanySort]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_Country] ON [dbo].[Prospect] ([Country]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_ImportDate] ON [dbo].[Prospect] ([ImportDate]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_LastFirst] ON [dbo].[Prospect] ([LastFirst]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_PostalCode] ON [dbo].[Prospect] ([PostalCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_ProspectID] ON [dbo].[Prospect] ([ProspectID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Prospect_StateProvince] ON [dbo].[Prospect] ([StateProvince]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Prospect] TO [IMIS]
GRANT SELECT ON  [dbo].[Prospect] TO [IMIS]
GRANT INSERT ON  [dbo].[Prospect] TO [IMIS]
GRANT DELETE ON  [dbo].[Prospect] TO [IMIS]
GRANT UPDATE ON  [dbo].[Prospect] TO [IMIS]
GO